Public Sector Restructuring and Internal Audit Board - RIAB, executes State Owned Enterprise Reform Initiatives. It has worked in association with National and International Agencies such as Commonwealth Secretariat, Commonwealth Association for Corporate Governance, OECD, Global Corporate Governance Forum, UNDP and the Academy of Corporate Governance. RIAB also carries out macro level fund management and monitoring and performance management of State Owned Enterprises.

---

---

A web application which will help state-owned enterprises to submit their monthly report online and the RIAB staff verify details as well as generate reports.Primarily the application may be having the following type of users

• RIAB Administrator
• RIAB Director
• Companies MD
• Companies Staff

1. Dashboard

This was supposed to have a consolidated view of the data received from Monthly reports submitted by the companies in the form of widgets and graphical representations.

2. User Management Module

This module enables CRUD (Create, Read, Update, Delete) functions to be applied on user’s. The created users can login to the system with the credentials.The users can be created with different types of roles. Each role is given specific permissions and the view would be different accordingly.

3. Company management module

CRUD functions can be applied to the state owned enterprises (Companies) according to the permissions given to the roles of the users.

4. Product module

Every company would have a set of products they make. This module gives the CRUD functionalities for products according to permission of roles.These products are used in other parts of the project.

5. Budget management module

This was one of the most important aspects of the project. Every company was provided with a budget and related matrices. The companies created the budget for an year which needed to be approved by RIAB. Only after this process companies will be able to submit monthly reports.

6. Monthly Reports Module

This part is the backbone of the project. Every company needs to submit a report of their income - expenditure data with lots of inputs for each month. Many of the inputs we calculated from previous month values.Some of the values are prefilled from the Budget data submitted . The monthly report needs to be created by a company staff and needs to be approved by Company MD. RIAB staff will go through and verify and Approve.There was a download as Excel feature in the same format as the currently used Excel.

7. Reports Module

This was the feature they were expecting to be the best feature of the application. The main one was the performance report which gave them an insight into yearly performance of all companies. They also needed a lot of other reports depending on various parameters.

8. Settings

This would include profile settings, password changes etc.

---

---

The project was decided to be developed in Laravel ( PHP framework ) with a database in MySQL.

Why Laravel?

• MVC Support and Object-Oriented Approach
• Built-In Authentication and Authorization
• Packaging System which helps in plug and play features
• Command line interface called as Artisan
• The Eloquent ORM
• Templating engine

Two environments namely develop and test were set up and when a feature was stable in develop and tested ok by tester’s it was to test. It was then reviewed by the point of contact at the client side. Agile methodology was followed throughout the development so that feedback was received from clients at each phase. Jobs were set up in Jenkins to facilitate continuous integration. Git was used for version control to monitor different stages of the application.Proper documentation was done about the requirements and a user manual was provided to the client complete with video reference for each feature.

---

Once the project was completed it saved a lot of time for the client and the management of data became a lot easier.There were a lot of features added, on the go in the project.

• 1. Turnover module - This was added on after it was found that this was something that could be reused once added.
• 2. Switch Company Option - When there are subunits of a company and the logged in user is a staff of the main company , the user would be able to switch between the companies and handle all the functionalities without going into trouble of logging in and out of the system.
• 3. Reminder emails - It was a tedious process to remind each company who has not submitted monthly reports . We set up a functionality which would take care of that. Reminder mails would be sent to companies as well RIAB will be indicated if any company has not submitted a report after the due date.
• 4. Financial year configuration - Financial year format needed for the application could be configured through this interface. This was done taking into consideration financial year from and to months could change.
• 5. Company category configuration - The categories under which the companies come can be configured through this interface.
• 6. Product Unit configuration - Different types of Products have different types of metrics. This can be configured here and reused across the application.
• 7. Assigning companies to RIAB staff - This was also a requirement that came up along development. They needed to assign companies to RIAB staff who were assigned to take care of them. As our architecture was good this did not turn out to be such a big change.

---

• Export as excel option for all important data
• Permission management which enables smooth integration of new Roles
• Email reminders and In app Notifications which helps in timely actions to be taken.
• System configurations - All reusable settings and data can be created and reused.
• Agile development which helped in timely feedback from client
• Custom reports can be created according to data needed.
• Charts & Graphs with drill down reports for overview

---

• Language: PHP 7.2
• Database: MySQL - 4.8.4
• Framework: Laravel 5.8.26
• Others
  • Javascript
  • Jquery
  • CSS
  • Bootstrap
• IDE: Netbeans 11
• Ticket Tracking: YouTrack
• Version Control: BitBucket
• Repository: Git
• Wireframe: Draw.io, Mind map
• Continuous integration Tool: Jenkins